﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace BKIDS.CDBNames
{
    class CM_DM_TU_DIEN
    {
        public const string ID = "ID";
        public const string MA_TU_DIEN = "MA_TU_DIEN";
        public const string ID_LOAI_TU_DIEN = "ID_LOAI_TU_DIEN";
        public const string TEN_NGAN = "TEN_NGAN";
        public const string TEN = "TEN";
        public const string GHI_CHU = "GHI_CHU";
    }



    class HT_CHUC_NANG
    {
        public const string ID = "ID";
        public const string TEN_CHUC_NANG = "TEN_CHUC_NANG";
        public const string URL_FORM = "URL_FORM";
        public const string TRANG_THAI_YN = "TRANG_THAI_YN";
        public const string VI_TRI = "VI_TRI";
        public const string CHUC_NANG_PARENT_ID = "CHUC_NANG_PARENT_ID";
        public const string HIEN_THI_YN = "HIEN_THI_YN";
    }

    class HT_QUYEN_GROUP
    {
        public const string ID = "ID";
        public const string ID_USER_GROUP = "ID_USER_GROUP";
        public const string ID_QUYEN = "ID_QUYEN";
    }

    class HT_USER_GROUP
    {
        public const string ID = "ID";
        public const string USER_GROUP_NAME = "USER_GROUP_NAME";
        public const string DESCRIPTION = "DESCRIPTION";
    }

    class HT_QUYEN_USER
    {
        public const string ID = "ID";
        public const string ID_USER = "ID_USER";
        public const string ID_QUYEN = "ID_QUYEN";
    }

    class HT_NGUOI_SU_DUNG
    {
        public const string ID = "ID";
        public const string TEN_TRUY_CAP = "TEN_TRUY_CAP";
        public const string TEN = "TEN";
        public const string MAT_KHAU = "MAT_KHAU";
        public const string NGAY_TAO = "NGAY_TAO";
        public const string NGUOI_TAO = "NGUOI_TAO";
        public const string TRANG_THAI = "TRANG_THAI";
        public const string BUILT_IN_YN = "BUILT_IN_YN";
        public const string ID_USER_GROUP = "ID_USER_GROUP";
        public const string ID_TRAINING_PROJECT = "ID_TRAINING_PROJECT";
    }

    public class CM_DM_TU_DIEN
    {
        public const string ID = "ID";
        public const string MA_TU_DIEN = "MA_TU_DIEN";
        public const string ID_LOAI_TU_DIEN = "ID_LOAI_TU_DIEN";
        public const string TEN_NGAN = "TEN_NGAN";
        public const string TEN = "TEN";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class CM_DM_LOAI_TD
    {
        public const string ID = "ID";
        public const string MA_LOAI = "MA_LOAI";
        public const string TEN_LOAI = "TEN_LOAI";
    }

    public class DM_DOI_TAC
    {
        public const string ID = "ID";
        public const string HO_TEN = "HO_TEN";
        public const string EMAIL = "EMAIL";
        public const string SO_DIEN_THOAI = "SO_DIEN_THOAI";
        public const string DIA_CHI = "DIA_CHI";
        public const string NOI_CONG_TAC = "NOI_CONG_TAC";
        public const string VI_TRI_CONG_TAC = "VI_TRI_CONG_TAC";
    }

    public class DM_KHACH_HANG
    {
        public const string ID = "ID";
        public const string HO_TEN = "HO_TEN";
        public const string SO_DIEN_THOAI = "SO_DIEN_THOAI";
        public const string EMAIL = "EMAIL";
        public const string DIA_CHI = "DIA_CHI";
        public const string NOI_CONG_TAC = "NOI_CONG_TAC";
        public const string VI_TRI_CONG_VIEC = "VI_TRI_CONG_VIEC";
    }

    public class DM_THANH_VIEN
    {
        public const string ID = "ID";
        public const string MA_THANH_VIEN = "MA_THANH_VIEN";
        public const string TEN_DANG_NHAP = "TEN_DANG_NHAP";
        public const string MAT_KHAU = "MAT_KHAU";
        public const string HO_VA_TEN_DEM = "HO_VA_TEN_DEM";
        public const string TEN_THANH_VIEN = "TEN_THANH_VIEN";
        public const string NGAY_SINH = "NGAY_SINH";
        public const string GIOI_TINH_YN = "GIOI_TINH_YN";
        public const string QUE_QUAN = "QUE_QUAN";
        public const string DIA_CHI_HIEN_TAI = "DIA_CHI_HIEN_TAI";
        public const string MOBILE_PHONE = "MOBILE_PHONE";
        public const string EMAIL_CA_NHAN = "EMAIL_CA_NHAN";
        public const string EMAIL_BKINDEX = "EMAIL_BKINDEX";
        public const string ANH_CA_NHAN = "ANH_CA_NHAN";
        public const string KHOA_NGANH = "KHOA_NGANH";
        public const string TRUONG_DAO_TAO = "TRUONG_DAO_TAO";
        public const string SO_TAI_KHOAN = "SO_TAI_KHOAN";
        public const string TEN_NGAN_HANG = "TEN_NGAN_HANG";
        public const string SO_CMTND = "SO_CMTND";
        public const string NGAY_CAP = "NGAY_CAP";
        public const string NOI_CAP = "NOI_CAP";
        public const string MA_SO_THUE = "MA_SO_THUE";
        public const string DESCRIPTION = "DESCRIPTION";
        public const string NGAY_VAO_PROJECT = "NGAY_VAO_PROJECT";
    }

    public class V_DM_THANH_VIEN
    {
        public const string ID = "ID";
        public const string MA_THANH_VIEN = "MA_THANH_VIEN";
        public const string TEN_DANG_NHAP = "TEN_DANG_NHAP";
        public const string MAT_KHAU = "MAT_KHAU";
        public const string HO_VA_TEN_DEM = "HO_VA_TEN_DEM";
        public const string TEN_THANH_VIEN = "TEN_THANH_VIEN";
        public const string TEN_DAY_DU = "TEN_DAY_DU";
        public const string NGAY_SINH = "NGAY_SINH";
        public const string GIOI_TINH_YN = "GIOI_TINH_YN";
        public const string QUE_QUAN = "QUE_QUAN";
        public const string DIA_CHI_HIEN_TAI = "DIA_CHI_HIEN_TAI";
        public const string MOBILE_PHONE = "MOBILE_PHONE";
        public const string EMAIL_CA_NHAN = "EMAIL_CA_NHAN";
        public const string EMAIL_BKINDEX = "EMAIL_BKINDEX";
        public const string ANH_CA_NHAN = "ANH_CA_NHAN";
        public const string KHOA_NGANH = "KHOA_NGANH";
        public const string TRUONG_DAO_TAO = "TRUONG_DAO_TAO";
        public const string SO_TAI_KHOAN = "SO_TAI_KHOAN";
        public const string TEN_NGAN_HANG = "TEN_NGAN_HANG";
        public const string SO_CMTND = "SO_CMTND";
        public const string NGAY_CAP = "NGAY_CAP";
        public const string NOI_CAP = "NOI_CAP";
        public const string MA_SO_THUE = "MA_SO_THUE";
        public const string DESCRIPTION = "DESCRIPTION";
        public const string NGAY_VAO_PROJECT = "NGAY_VAO_PROJECT"; 
    }


    public class DM_THANH_VIEN_VI_TRI
    {
        public const string ID = "ID";
        public const string ID_THANH_VIEN = "ID_THANH_VIEN";
        public const string ID_VI_TRI_CONG_VIEC = "ID_VI_TRI_CONG_VIEC";
        public const string ID_LEVEL = "ID_LEVEL";
    }
    public class DM_DU_AN
    {
        public const string ID = "ID";
        public const string MA_DU_AN = "MA_DU_AN";
        public const string TEN_DU_AN = "TEN_DU_AN";
        public const string ID_LOAI_DU_AN = "ID_LOAI_DU_AN";
        public const string NGAY_KY_HOP_DONG = "NGAY_KY_HOP_DONG";
        public const string GIA_TRI_HOP_DONG = "GIA_TRI_HOP_DONG";
        public const string GIA_TRI_THUC_NHAN = "GIA_TRI_THUC_NHAN";
        public const string ID_TRANG_THAI_DU_AN = "ID_TRANG_THAI_DU_AN";
        public const string ID_KHACH_HANG = "ID_KHACH_HANG";
        public const string CO_THUE_SUAT_YN = "CO_THUE_SUAT_YN";
        public const string GHI_CHU = "GHI_CHU";
        public const string GHI_CHU1 = "GHI_CHU1";
        public const string GHI_CHU2 = "GHI_CHU2";
    }
    public class DM_CONG_VIEC_DU_AN
    {
        public const string ID = "ID";
        public const string TEN_CONG_VIEC = "TEN_CONG_VIEC";
        public const string ID_LOAI_DU_AN = "ID_LOAI_DU_AN";
        public const string MA_DON_VI_TINH = "MA_DON_VI_TINH";
        public const string HE_SO_DEFAULT = "HE_SO_DEFAULT";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class DM_THANH_VIEN_DU_AN
    {
        public const string ID = "ID";
        public const string ID_THANH_VIEN = "ID_THANH_VIEN";
        public const string ID_DU_AN = "ID_DU_AN";
    }

    public class V_DM_THANH_VIEN_DU_AN
    {
        public const string ID = "ID";
        public const string ID_THANH_VIEN = "ID_THANH_VIEN";
        public const string ID_DU_AN = "ID_DU_AN";
        public const string HO_TEN_TV = "HO_TEN_TV";
        public const string TEN_DU_AN = "TEN_DU_AN";
    }


    public class GD_CONG_VIEC_THANH_VIEN_TIEN_DO_DU_AN
    {
        public const string ID = "ID";
        public const string ID_DU_AN = "ID_DU_AN";
        public const string ID_CONG_VIEC_DU_AN = "ID_CONG_VIEC_DU_AN";
        public const string ID_THANH_VIEN = "ID_THANH_VIEN";
        public const string ID_TRANG_THAI_CONG_VIEC = "ID_TRANG_THAI_CONG_VIEC";
        public const string HE_SO = "HE_SO";
        public const string THOI_GIAN_BAT_DAU = "THOI_GIAN_BAT_DAU";
        public const string THOI_GIAN_KET_THUC = "THOI_GIAN_KET_THUC";
        public const string GHI_CHU = "GHI_CHU";
    }
}
